from sqlalchemy import create_engine

from app import SQLALCHEMY_DATABASE_URI, dBSession
from app.Models.Model import Base, FND

engine = create_engine(SQLALCHEMY_DATABASE_URI, echo=True)  # 创建连接
Base.metadata.create_all(engine)

f = FND(gpc_fnd='432/A00A', model='T1A', part_name='左前门护板带开关总成', qty=6, gpc='432', fnd='A00A', fnd_cn='左前门护板总成')
dBSession.add(f)
f = FND(gpc_fnd='432/A00B', model='T1A', part_name='右前门护板带开关总成', qty=5, gpc='432', fnd='A00B', fnd_cn='右前门护板总成')
dBSession.add(f)
f = FND(gpc_fnd='432/A00C', model='E0Y', part_name='左后门护板总成', qty=8, gpc='432', fnd='A00C', fnd_cn='左后门护板总成')
dBSession.add(f)
f = FND(gpc_fnd='432/A00D', model='E0Y', part_name='右后门护板总成', qty=6, gpc='432', fnd='A00D', fnd_cn='右后门护板总成')
dBSession.add(f)
f = FND(gpc_fnd='432/A00W', model='T1A', part_name='左前门内三角块总成', qty=1, gpc='432', fnd='A00W', fnd_cn='左前门内三角块总成')
dBSession.add(f)
f = FND(gpc_fnd='432/A00X', model='T1A', part_name='右前门内三角块总成', qty=1, gpc='432', fnd='A00X', fnd_cn='右前门内三角块总成')
dBSession.add(f)
f = FND(gpc_fnd='432/A02F', model='T26', part_name='左前门拉手盒垫片', qty=1, gpc='432', fnd='A02F', fnd_cn='左前门拉手盒垫片')
dBSession.add(f)
f = FND(gpc_fnd='432/A02G', model='T26', part_name='右前门拉手盒垫片', qty=1, gpc='432', fnd='A02G', fnd_cn='右前门拉手盒垫片')
dBSession.add(f)
f = FND(gpc_fnd='432/A02H', model='T26', part_name='左后门拉手盒垫片', qty=1, gpc='432', fnd='A02H', fnd_cn='左后门拉手盒垫片')
dBSession.add(f)
f = FND(gpc_fnd='432/A02J', model='T26', part_name='右后门拉手盒垫片', qty=1, gpc='432', fnd='A02J', fnd_cn='右后门拉手盒垫片')
dBSession.add(f)
f = FND(gpc_fnd='432/A05E', model='T1D', part_name='十字槽钮扣头自攻螺钉', qty=6, gpc='432', fnd='A05E', fnd_cn='螺钉-右前门护板到门钣金')
dBSession.add(f)
f = FND(gpc_fnd='432/A06F', model='E03', part_name='十字槽钮扣头自攻螺钉', qty=4, gpc='432', fnd='A06F', fnd_cn='螺钉-左前门护板到支架')
dBSession.add(f)
f = FND(gpc_fnd='432/A06J', model='T26', part_name='十字槽钮扣头自攻螺钉', qty=10, gpc='432', fnd='A06J', fnd_cn='螺钉-右后门护板到支架')
dBSession.add(f)
f = FND(gpc_fnd='432/A14B', model='T1A', part_name='左前门内装饰板总成', qty=2, gpc='432', fnd='A14B', fnd_cn='左前门内装饰板总成')
dBSession.add(f)
f = FND(gpc_fnd='432/A14C', model='T1A', part_name='右前门内装饰板总成', qty=2, gpc='432', fnd='A14C', fnd_cn='右前门内装饰板总成')
dBSession.add(f)
f = FND(gpc_fnd='432/A14D', model='T1A', part_name='左后门内装饰板总成', qty=1, gpc='432', fnd='A14D', fnd_cn='左后门内装饰板总成')
dBSession.add(f)
f = FND(gpc_fnd='432/A14E', model='T1A', part_name='右后门内装饰板总成', qty=1, gpc='432', fnd='A14E', fnd_cn='右后门内装饰板总成')
dBSession.add(f)
f = FND(gpc_fnd='432/A14R', model='T26', part_name='左前门护板带开关总成', qty=13, gpc='432', fnd='A14R', fnd_cn='左前门护板带开关总成')
dBSession.add(f)
f = FND(gpc_fnd='432/A14S', model='T26', part_name='右前门护板带开关总成', qty=17, gpc='432', fnd='A14S', fnd_cn='右前门护板带开关总成')
dBSession.add(f)
f = FND(gpc_fnd='432/A14T', model='T26', part_name='左后门护板带开关总成', qty=16, gpc='432', fnd='A14T', fnd_cn='左后门护板带开关总成')
dBSession.add(f)
f = FND(gpc_fnd='432/A14U', model='T26', part_name='右后门护板带开关总成', qty=16, gpc='432', fnd='A14U', fnd_cn='右后门护板带开关总成')
dBSession.add(f)
f = FND(gpc_fnd='432/A16T', model='T26', part_name='左前门内窗框装饰板', qty=1, gpc='432', fnd='A16T', fnd_cn='左前门内窗框装饰板')
dBSession.add(f)
f = FND(gpc_fnd='432/A16U', model='T26', part_name='右前门内窗框装饰板', qty=1, gpc='432', fnd='A16U', fnd_cn='右前门内窗框装饰板')
dBSession.add(f)
f = FND(gpc_fnd='432/A16V', model='T26', part_name='左后门内窗框装饰板', qty=2, gpc='432', fnd='A16V', fnd_cn='左后门内窗框装饰板')
dBSession.add(f)
f = FND(gpc_fnd='432/A16W', model='T26', part_name='右后门内窗框装饰板', qty=2, gpc='432', fnd='A16W', fnd_cn='右后门内窗框装饰板')
dBSession.add(f)
f = FND(gpc_fnd='432/A18F', model='T26', part_name='左后门遮阳帘挂钩', qty=1, gpc='432', fnd='A18F', fnd_cn='左后门遮阳帘挂钩')
dBSession.add(f)
f = FND(gpc_fnd='432/A18G', model='T26', part_name='右后门遮阳帘挂钩', qty=1, gpc='432', fnd='A18G', fnd_cn='右后门遮阳帘挂钩')
dBSession.add(f)
f = FND(gpc_fnd='543/A00F', model='T26', part_name='堵件14#', qty=1, gpc='543', fnd='A00F', fnd_cn='堵件-总装')
dBSession.add(f)
f = FND(gpc_fnd='732/A02L', model='T26', part_name='扬声器品牌Logo', qty=1, gpc='732', fnd='A02L', fnd_cn='扬声器品牌Logo')
dBSession.add(f)
f = FND(gpc_fnd='861/A00G', model='T26', part_name='左前门线束', qty=5, gpc='861', fnd='A00G', fnd_cn='左前门线束')
dBSession.add(f)
f = FND(gpc_fnd='861/A00H', model='T26', part_name='右前门线束', qty=3, gpc='861', fnd='A00H', fnd_cn='右前门线束')
dBSession.add(f)
f = FND(gpc_fnd='861/A00J', model='T26', part_name='左后门线束', qty=6, gpc='861', fnd='A00J', fnd_cn='左后门线束')
dBSession.add(f)
f = FND(gpc_fnd='861/A00V', model='E0Y', part_name='后门线束', qty=2, gpc='861', fnd='A00V', fnd_cn='后门线束')
dBSession.add(f)
f = FND(gpc_fnd='B41/A01Q', model='T26', part_name='内六角花形钮扣头螺钉和平垫圈组合件', qty=1, gpc='B41', fnd='A01Q', fnd_cn='螺栓-门锁到钣金')
dBSession.add(f)
f = FND(gpc_fnd='B41/A01W', model='T1A', part_name='儿童保险杆护套', qty=2, gpc='B41', fnd='A01W', fnd_cn='右后儿童保险杆护套')
dBSession.add(f)
f = FND(gpc_fnd='B46/A00H', model='T26', part_name='左前门框密封条', qty=1, gpc='B46', fnd='A00H', fnd_cn='左前门框密封条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A00J', model='T26', part_name='右前门框密封条', qty=1, gpc='B46', fnd='A00J', fnd_cn='右前门框密封条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A00K', model='T26', part_name='左后门框密封条', qty=1, gpc='B46', fnd='A00K', fnd_cn='左后门框密封条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A00L', model='T26', part_name='右后门框密封条', qty=1, gpc='B46', fnd='A00L', fnd_cn='右后门框密封条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A01A', model='E0Y', part_name='左后门内挡水条', qty=1, gpc='B46', fnd='A01A', fnd_cn='左前门内挡水条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A01B', model='E0Y', part_name='右前门内挡水条', qty=1, gpc='B46', fnd='A01B', fnd_cn='右前门内挡水条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A01C', model='E03', part_name='左后门内挡水条', qty=1, gpc='B46', fnd='A01C', fnd_cn='左后门内挡水条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A01D', model='E0Y', part_name='右后门内挡水条', qty=1, gpc='B46', fnd='A01D', fnd_cn='右后门内挡水条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A01L', model='T1A', part_name='左前门下部密封条', qty=1, gpc='B46', fnd='A01L', fnd_cn='左前门下部密封条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A01M', model='T1A', part_name='右前门下部密封条', qty=1, gpc='B46', fnd='A01M', fnd_cn='右前门下部密封条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A01N', model='T1A', part_name='左后门下部密封条', qty=1, gpc='B46', fnd='A01N', fnd_cn='左后门下部密封条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A01P', model='T1A', part_name='右后门下部密封条', qty=1, gpc='B46', fnd='A01P', fnd_cn='右后门下部密封条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A01W', model='E0Y', part_name='左前门三角窗密封条', qty=1, gpc='B46', fnd='A01W', fnd_cn='左前门三角窗密封条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A01X', model='E0Y', part_name='右前门三角窗密封条', qty=1, gpc='B46', fnd='A01X', fnd_cn='右前门三角窗密封条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A03U', model='E0Y', part_name='左前门A柱门缝密封条', qty=1, gpc='B46', fnd='A03U', fnd_cn='左前门A柱门缝密封条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A03V', model='E0Y', part_name='右前门A柱门缝密封条', qty=1, gpc='B46', fnd='A03V', fnd_cn='右前门A柱门缝密封条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A03W', model='E0Y', part_name='左后门B柱门缝密封条', qty=1, gpc='B46', fnd='A03W', fnd_cn='左后门B柱门缝密封条')
dBSession.add(f)
f = FND(gpc_fnd='B46/A03X', model='E0Y', part_name='右后门B柱门缝密封条', qty=1, gpc='B46', fnd='A03X', fnd_cn='右后门B柱门缝密封条')
dBSession.add(f)
f = FND(gpc_fnd='B48/A00B', model='T1A', part_name='缓冲块', qty=1, gpc='B48', fnd='A00B', fnd_cn='缓冲块-前门下到侧围')
dBSession.add(f)
f = FND(gpc_fnd='B48/A00D', model='T26', part_name='固定缓冲块', qty=2, gpc='B48', fnd='A00D', fnd_cn='缓冲块-后门下到侧围')
dBSession.add(f)
f = FND(gpc_fnd='B49/A00B', model='E03', part_name='前门限位器总成', qty=2, gpc='B49', fnd='A00B', fnd_cn='左前门限位器总成')
dBSession.add(f)
f = FND(gpc_fnd='B49/A00C', model='E0Y', part_name='前门限位器总成', qty=2, gpc='B49', fnd='A00C', fnd_cn='右前门限位器总成')
dBSession.add(f)
f = FND(gpc_fnd='B49/A00D', model='E0Y', part_name='后门限位器总成', qty=2, gpc='B49', fnd='A00D', fnd_cn='左后门限位器总成')
dBSession.add(f)
f = FND(gpc_fnd='B53/A00L', model='T26', part_name='左前侧门角窗总成', qty=1, gpc='B53', fnd='A00L', fnd_cn='左前侧门角窗总成')
dBSession.add(f)
f = FND(gpc_fnd='B53/A00M', model='T26', part_name='右前侧门角窗总成', qty=1, gpc='B53', fnd='A00M', fnd_cn='右前侧门角窗总成')
dBSession.add(f)
f = FND(gpc_fnd='G13/A00P', model='T26', part_name='前门限位器总成', qty=2, gpc='G13', fnd='A00P', fnd_cn='前门限位器总成')
dBSession.add(f)
f = FND(gpc_fnd='G1Y/A05Q', model='E03', part_name='堵件22#', qty=4, gpc='G1Y', fnd='A05Q', fnd_cn='总装堵件-左前门孔')
dBSession.add(f)
f = FND(gpc_fnd='G23/A00N', model='T1D', part_name='前车门限位器总成', qty=2, gpc='G23', fnd='A00N', fnd_cn='前门限位器总成')
dBSession.add(f)
f = FND(gpc_fnd='G33/A00N', model='T26', part_name='后车门限位器总成', qty=1, gpc='G33', fnd='A00N', fnd_cn='后门限位器总成')
dBSession.add(f)
f = FND(gpc_fnd='G34/A02K', model='T18', part_name='左后门玻璃后下导轨总成', qty=1, gpc='G34', fnd='A02K', fnd_cn='左后门玻璃后下导轨总成')
dBSession.add(f)
f = FND(gpc_fnd='G44/A02M', model='T18', part_name='右后门玻璃后下导轨总成', qty=1, gpc='G44', fnd='A02M', fnd_cn='右后门玻璃后下导轨总成')
dBSession.add(f)
dBSession.commit()